﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Collections;

namespace DBUtility
{
    /// <summary>
    /// 数据库访问类接口
    /// </summary>
    public interface IDataAccess
    {
        DataTable ExecuteProcDataTable(string ProcName, Hashtable hs);
        DataTable ExecuteProcDataTable(int nStartPage, int nPageSize, out int nTotalRec, string ProcName, Hashtable hs);
        void ExecuteProcNonQuery(string ProcName, Hashtable hs);
        object ExecuteProcScale(string ProcName, Hashtable hs);
        IDataReader ExecuteSQLDataReader(string strSql);
        IDataReader ExecuteSQLDataReader(string strSql, Hashtable hs);
        IDataReader ExecuteSQLDataReaderWithRowCount(string strSql);
        IDataReader ExecuteSQLDataReaderWithRowCount(string strSql, Hashtable hs);
        DataTable ExecuteSQLDataTable(string strSql);
        DataTable ExecuteSQLDataTable(string strSql, Hashtable hs);
        DataTable ExecuteSQLDataTable(out int TotalRec, string strSql, Hashtable hs);
        DataTable ExecuteSQLDataTable(int nStartPage, int nPageSize, out int nTotalRec, string strSql, Hashtable hs);
        DataTable ExecuteSQLDataTableEx(int nStartPage, int nPageSize, out int nTotalRec, string strSql, Hashtable hs);
        void ExecuteSQLNonQuery(string strSql);
        void ExecuteSQLNonQuery(string strSql, Hashtable hs);
        object ExecuteSQLScale(string strSql);
        object ExecuteSQLScale(string strSql, Hashtable hs);

        string ConStr { get; set; }
    }
}
